﻿-- =============================================
-- Author:		<Author,,Name>
-- Create date: <Create Date,,>
-- Description:	Return all values from the UDDI_Admin Table
-- =============================================
CREATE PROCEDURE [dbo].[usp_get_uddi_admin] 
	-- Add the parameters for the stored procedure here
	@ID int
AS
BEGIN
	-- SET NOCOUNT ON added to prevent extra result sets from
	-- interfering with SELECT statements.
	SET NOCOUNT ON;

	SELECT ID, SMTPServer, NotificationEmail, NotificationEnabled, AutoPublish, Contactname, ContactEmail, SMTPFromEmail, SMTPSubject, SMTPBody, UDDIServer, Anonymous, ServiceInterval, CategorySchema, LdapRoot
	FROM UDDI_Admin where ID = @ID


END
